SnowPro Core v1.0

Page:    1 / 74   
Exam contains 1107 questions
Expand All

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

  • A. Standard
  • B. Premier
  • C. Enterprise
  • D. Business Critical Edition


Answer : D

Reference:
https://docs.snowflake.com/en/user-guide/intro-editions.html

Select the three types of tables that exist within Snowflake. (Choose three.)

  • A. Temporary
  • B. Transient
  • C. Provisional
  • D. Permanent


Answer : ABD

Reference:
https://community.snowflake.com/s/article/Making-Transient-table-by-Default

True or False: Snowpipe via REST API can only reference External Stages as source.

  • A. True
  • B. False


Answer : B

Reference:
https://community.snowflake.com/s/article/Making-Transient-table-by-Default

True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

  • A. True
  • B. False


Answer : A

Reference:
https://docs.snowflake.com/en/user-guide-connecting.html

True or False: It is possible to load data into Snowflake without creating a named File Format object.

  • A. True
  • B. False


Answer : A

Reference:
https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

  • A. True
  • B. False


Answer : B

Which of the following statements are true of Snowflake data loading? (Choose three.)

  • A. VARIANT ג€nullג€ values are not the same as SQL NULL values
  • B. It is recommended to do frequent, single row DMLs
  • C. It is recommended to validate the data before loading into the Snowflake target table
  • D. It is recommended to use staging tables to manage MERGE statements


Answer : ACD

Which statements are true of micro-partitions? (Choose two.)

  • A. They are approximately 16MB in size
  • B. They are stored compressed only if COMPRESS=TRUE on Table
  • C. They are immutable
  • D. They are only encrypted in the Enterprise edition and above


Answer : AC

Reference:
https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-731ddc983c69

True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

  • A. True
  • B. False


Answer : B

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

  • A. The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
  • B. The same exact query will return the precomputed results if the underlying data hasnג€™t changed and the results were last accessed within previous 24 hour period
  • C. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
  • D. The ג€24 hourג€ timer on the precomputed results gets renewed every time the exact query is executed


Answer : BD

Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

  • A. Scaling rhythmically
  • B. Scaling max
  • C. Scaling out
  • D. Scaling up


Answer : D

Which statement best describes Snowflake tables?

  • A. Snowflake tables are logical representations of underlying physical data
  • B. Snowflake tables are the physical instantiation of data loaded into Snowflake
  • C. Snowflake tables require that clustering keys be defined to perform optimally
  • D. Snowflake tables are owned by a user


Answer : A

Reference:
https://docs.snowflake.com/en/user-guide/tables-micro-partitions.html

Which item in the Data Warehouse migration process does not apply in Snowflake?

  • A. Migrate Users
  • B. Migrate Schemas
  • C. Migrate Indexes
  • D. Build the Data Pipeline


Answer : C

Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: (Choose two.)

  • A. Temporary Tables
  • B. Transient Tables
  • C. Provisional Tables
  • D. Permanent Tables


Answer : AB

Reference:
https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

What is the maximum compressed row size in Snowflake?

  • A. 8KB
  • B. 16MB
  • C. 50MB
  • D. 4000GB


Answer : B

Page:    1 / 74   
Exam contains 1107 questions
Expand All

Talk to us!

Have any questions or issues ? Please dont hesitate to contact us

[email protected]

Certlibrary.com is owned by MBS Tech Limited: Room 1905 Nam Wo Hong Building, 148 Wing Lok Street, Sheung Wan, Hong Kong. Company registration number: 2310926
Certlibrary doesn't offer Real Microsoft Exam Questions. Certlibrary Materials do not contain actual questions and answers from Cisco's Certification Exams.
CFA Institute does not endorse, promote or warrant the accuracy or quality of Certlibrary. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Terms & Conditions | Privacy Policy